﻿<cfscript>
/** 
* ORM StudentMarkProfile
* 
* @hint "Hibernate persistenter t_student_profile. 学生成绩档案辅助信息" 
* 
*/ 

component 
	displayname="public.service.orm.senate.StudentMarkProfile" 
	output=false 
	persistent=true 
	selectBeforeUpdate=true dynamicInsert=true dynamicUpdate=true 
	cacheuse="Transactional" 
	entityname="StudentMarkProfile" 
	table="t_student_profile"
	{

	property type="string" name="ProfileID" column="stu_id" fieldtype="id" generator="foreign" params="{property='Student'}" hint="学号";
		
	property type="numeric" name="Credit" column="credit" hint="总学分";

	property type="numeric" name="CreditRequired" column="credit_req" hint="必修课学分";
	property type="numeric" name="CreditOptional" column="credit_opt" hint="限选课学分";
	property type="numeric" name="CreditPhysical" column="credit_phy" hint="体育课学分";
	property type="numeric" name="CreditCommon" column="credit_com" hint="任选课学分";
	property type="numeric" name="CreditFailure" column="credit_failure" hint="不及格学分";

	property type="numeric" name="CreditPointRequired" column="credit_req_pt" hint="必修课绩点";
	property type="numeric" name="CreditPointAvgRequired" column="credit_req_avgpt" hint="必修课平均绩点";

	property type="numeric" name="CreditPoint" column="credit_pt" hint="课程绩点";
	property type="numeric" name="CreditPointAvg" column="credit_avgpt" hint="平均绩点";

	property type="numeric" name="SubjectRank" column="subject_rank" hint="专业年级必修课绩点排名百分位";
	property type="numeric" name="SubjectIndex" column="subject_idx" hint="专业年级排位";
		
	property name="Student" fieldtype="one-to-one" cfc="Student" constrained="true" hint="学生档案";
			
}

</cfscript>
